﻿﻿﻿<%@ page import="java.util.List" %>
<%@ page import="studentinformationmanagementsystem.entity.Student" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
    <head>
		<%
			List<Student>students=(List<Student>)request.getAttribute("students");
		%>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
        <title>学生信息管理系统</title>
		
		<!-- Favicon -->
        <link rel="shortcut icon" href="assets/img/favicon.png">
	
		<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Poppins:ital,wght@0,500;0,600;0,700;1,400&display=swap">
		
		<!-- Bootstrap CSS -->
        <link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css">
		
		<!-- Fontawesome CSS -->
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">

		<!-- Datatables CSS -->
		<link rel="stylesheet" href="assets/plugins/datatables/datatables.min.css">

		<script src="../../js/sweetalert.min.js" type="text/javascript"></script>
		<script src="../../js/jquery-1.11.3.min.js"></script>



		<!-- Main CSS -->
        <link rel="stylesheet" href="assets/css/style.css">
    </head>
    <body>
		
		<!-- Main Wrapper -->
        <div class="main-wrapper">

			<!--页面头部 -->
			<div class="header">

				<!-- Logo -->
				<div class="header-left">
					<a href="index.html" class="logo">
						<img src="assets/img/logo.png" alt="Logo">
					</a>
					<a href="index.html" class="logo logo-small">
						<img src="assets/img/logo-small.png" alt="Logo" width="30" height="30">
					</a>
				</div>
				<!-- /Logo -->

				<a href="javascript:void(0);" id="toggle_btn">
					<i class="fas fa-align-left"></i>
				</a>

				<!-- Search Bar -->
				<div class="top-nav-search">
					<form>
						<input type="text" class="form-control" placeholder="搜索">
						<button class="btn" type="submit"><i class="fas fa-search"></i></button>
					</form>
				</div>
				<!-- /Search Bar -->

				<!-- Mobile Menu Toggle -->
				<a class="mobile_btn" id="mobile_btn">
					<i class="fas fa-bars"></i>
				</a>
				<!-- /Mobile Menu Toggle -->

				<!-- Header Right Menu -->
				<ul class="nav user-menu">

					<!-- Notifications -->
					<li class="nav-item dropdown noti-dropdown">
						<a href="#" class="dropdown-toggle nav-link" data-toggle="dropdown">
							<i class="far fa-bell"></i> <span class="badge badge-pill">3</span>
						</a>
						<div class="dropdown-menu notifications">
							<div class="topnav-dropdown-header">
								<span class="notification-title">通知</span>
								<a href="javascript:void(0)" class="clear-noti"> 清除</a>
							</div>
							<div class="noti-content">
								<ul class="notification-list">
									<li class="notification-message">
										<a href="#">
											<div class="media">
												<span class="avatar avatar-sm">
													<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-02.jpg">
												</span>
												<div class="media-body">
													<p class="noti-details"><span class="noti-title">Carlson Tech</span> has approved <span class="noti-title">your estimate</span></p>
													<p class="noti-time"><span class="notification-time">4 mins ago</span></p>
												</div>
											</div>
										</a>
									</li>
									<li class="notification-message">
										<a href="#">
											<div class="media">
												<span class="avatar avatar-sm">
													<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-11.jpg">
												</span>
												<div class="media-body">
													<p class="noti-details"><span class="noti-title">International Software Inc</span> has sent you a invoice in the amount of <span class="noti-title">$218</span></p>
													<p class="noti-time"><span class="notification-time">6 mins ago</span></p>
												</div>
											</div>
										</a>
									</li>
									<li class="notification-message">
										<a href="#">
											<div class="media">
												<span class="avatar avatar-sm">
													<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-17.jpg">
												</span>
												<div class="media-body">
													<p class="noti-details"><span class="noti-title">John Hendry</span> sent a cancellation request <span class="noti-title">Apple iPhone XR</span></p>
													<p class="noti-time"><span class="notification-time">8 mins ago</span></p>
												</div>
											</div>
										</a>
									</li>
									<li class="notification-message">
										<a href="#">
											<div class="media">
												<span class="avatar avatar-sm">
													<img class="avatar-img rounded-circle" alt="User Image" src="assets/img/profiles/avatar-13.jpg">
												</span>
												<div class="media-body">
													<p class="noti-details"><span class="noti-title">Mercury Software Inc</span> added a new product <span class="noti-title">Apple MacBook Pro</span></p>
													<p class="noti-time"><span class="notification-time">12 mins ago</span></p>
												</div>
											</div>
										</a>
									</li>
								</ul>
							</div>
							<div class="topnav-dropdown-footer">
								<a href="#">View all Notifications</a>
							</div>
						</div>
					</li>
					<!-- /Notifications -->

					<!-- User Menu -->
					<li class="nav-item dropdown has-arrow">
						<a href="#" class="dropdown-toggle nav-link" data-toggle="dropdown">
							<span class="user-img"><img class="rounded-circle" src="assets/img/profiles/avatar-01.jpg" width="31" alt="Ryan Taylor"></span>
						</a>
						<div class="dropdown-menu">
							<div class="user-header">
								<div class="avatar avatar-sm">
									<img src="assets/img/profiles/avatar-01.jpg" alt="User Image" class="avatar-img rounded-circle">
								</div>
								<div class="user-text">
									<h6>Ryan Taylor</h6>
									<p class="text-muted mb-0">Administrator</p>
								</div>
							</div>
							<a class="dropdown-item" href="profile.html">我的资料</a>
							<a class="dropdown-item" href="inbox.html">邮箱</a>
							<a class="dropdown-item" href="login.html">注销</a>
						</div>
					</li>
					<!-- /User Menu -->

				</ul>
				<!-- /Header Right Menu -->

			</div>
			<!-- /Header -->

			<!-- Sidebar -->
			<div class="sidebar" id="sidebar">
				<div class="sidebar-inner slimscroll">
					<div id="sidebar-menu" class="sidebar-menu">
						<ul>
							<li class="menu-title">
								<span>主菜单</span>
							</li>
							<li >
								<a href="index.html"><i class="fas fa-th-large"></i> <span>首页</span></a>
							</li>
							<li class="submenu active">
								<a href="#"><i class="fas fa-user-graduate"></i> <span> 学生管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="students.jsp" class="active">查看所有学生</a></li>
									<li><a href="student-details.html">查看学生详情</a></li>
									<li><a href="add-student.html">添加学生信息</a></li>
									<li><a href="edit-student.jsp">修改学生信息</a></li>
								</ul>
							</li>
							<li class="submenu">
								<a href="#"><i class="fas fa-chalkboard-teacher"></i> <span> 教师管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="teachers.jsp">查看所有教师</a></li>
									<li><a href="teacher-details.html">查看教师详情</a></li>
									<li><a href="add-teacher.html">添加教师信息</a></li>
									<li><a href="edit-teacher.jsp">修改教师信息</a></li>
								</ul>
							</li>
							<li class="submenu">
								<a href="#"><i class="fas fa-building"></i> <span> 院系管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="departments.html">查看所有院系</a></li>
									<li><a href="add-department.html">添加院系信息</a></li>
									<li><a href="edit-department.html">修改院系信息</a></li>
								</ul>
							</li>
							<li class="submenu">
								<a href="#"><i class="fas fa-book-reader"></i> <span> 课程管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="subjects.jsp">查看所有课程</a></li>
									<li><a href="add-subject.jsp">添加课程信息</a></li>
									<li><a href="edit-subject.jsp">修改课程信息</a></li>
								</ul>
							</li>
							<li class="submenu">
								<a href="#"><i class="fas fa-user-graduate"></i> <span> 班级管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="clazz.html">查看所有班级</a></li>
									<li><a href="add-clazz.html">添加班级信息</a></li>
									<li><a href="edit-clazz.html">修改班级信息</a></li>
								</ul>
							</li>
							<li class="submenu">
								<a href="#"><i class="fas fa-building"></i> <span> 专业管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="major.html">查看所有专业</a></li>
									<li><a href="add-major.html">添加专业信息</a></li>
									<li><a href="edit-major.html">修改专业信息</a></li>
								</ul>
							</li>
							<li class="submenu ">
								<a href="#"><i class="fas fa-chalkboard-teacher"></i> <span> 选课管理</span> <span class="menu-arrow"></span></a>
								<ul>
									<li><a href="course.html">查看所有选修课</a></li>
									<li><a href="add-course.html">添加选修课信息</a></li>
									<li><a href="edit-course.html">修改选修课信息</a></li>
								</ul>
							</li>


						</ul>
					</div>
				</div>
			</div>
			<!-- /Sidebar -->
			
			<!-- Page Wrapper -->
            <div class="page-wrapper">
                <div class="content container-fluid">
				
					<!-- Page Header -->
					<div class="page-header">
						<div class="row align-items-center">
							<div class="col">
								<h3 class="page-title">学生列表</h3>
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="index.html">首页</a></li>
									<li class="breadcrumb-item active">学生</li>
								</ul>
							</div>
							<div class="col-auto text-right float-right ml-auto">
								<a href="#" class="btn btn-outline-primary mr-2"><i class="fas fa-download"></i> 下载</a>
								<a href="add-student.html" class="btn btn-primary"><i class="fas fa-plus"></i></a>
							</div>
						</div>
					</div>
					<!-- /Page Header -->
				
					<div class="row">
						<div class="col-sm-12">
						
							<div class="card card-table">
								<div class="card-body">
									<div class="table-responsive">
										<table class="table table-hover table-center mb-0 datatable">
											<thead>
												<tr>
													<th>ID</th>
													<th>学号</th>
													<th>姓名</th>
													<th>个人照片</th>
													<th>身份证号</th>
													<th>性别</th>
													<th>入学时间</th>
													<th>民族</th>
													<th>本人电话</th>
													<th>班级</th>
													<th>院系</th>
													<th>密码</th>
													<th>籍贯</th>
													<th>家庭住址</th>
													<th>政治面貌</th>
													<th>出生年月</th>
													<th>专业</th>
													<th>邮箱</th>
													<th>紧急联系人</th>
													<th>紧急联系人电话</th>
													<th class="text-right">操作</th>
												</tr>
											</thead>
											<tbody>
											<%
												if(students==null){
													response.sendRedirect("./student.do?action=queryAll");
												}else{
													for (int i = 0; i <students.size(); i++) {
														Student student = students.get(i);
											%>
											<tr>
												<td><%=student.getStudid()%></td>
												<td><%=student.getStudentid()%></td>
												<td><%=student.getStudentname()%></td>
												<td>
													<img src="/studentinformationmanagementsystems/studentinformationmanagement/<%=student.getPhotograph()%>"style="width: 150px; height: 150px;" alt="..." id="img">
												</td>
												<td><%=student.getIdnumber()%></td>
												<td><%=student.getSex()%></td>
												<td><%=student.getAdmissionDate()%></td>
												<td><%=student.getNation()%></td>
												<td><%=student.getPhone()%></td>
												<td><%=student.getClassandgrade()%></td>
												<td><%=student.getDepartment()%></td>
												<td><%=student.getPassword()%></td>
												<td><%=student.getNativeplace()%></td>
												<td><%=student.getHomeaddress()%></td>
												<td><%=student.getPoliticsstatus()%></td>
												<td><%=student.getBirthdate()%></td>
												<td><%=student.getMajor()%></td>
												<td><%=student.getMailbox()%></td>
												<td><%=student.getEmergencycontact()%></td>
												<td><%=student.getEmergencycontactphone()%></td>
												<td class="text-right">
													<div class="actions">
														<a href="#" class="btn btn-sm bg-success-light mr-2 btn-student-edit">
															<i class="fas fa-pen"></i>
														</a>
														<a href="#" class="btn btn-sm bg-danger-light btn-student-delete">
															<i class="fas fa-trash"></i>
														</a>
													</div>
												</td>

											</tr>
											<%
													}
												}
											%>


											</tbody>
										</table>
									</div>
								</div>
							</div>							
						</div>					
					</div>					
				</div>

				<!-- Footer -->
				<footer>
					<p>学生信息管理系统</p>
				</footer>
				<!-- /Footer -->				
			</div>
			<!-- /Page Wrapper -->
			
        </div>
		<!-- /Main Wrapper -->
		
		<!-- jQuery -->
        <script src="assets/js/jquery-3.5.1.min.js"></script>
		
		<!-- Bootstrap Core JS -->
        <script src="assets/js/popper.min.js"></script>
        <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
		
		<!-- Slimscroll JS -->
		<script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
		
		<!-- Datatables JS -->
		<script src="assets/plugins/datatables/datatables.min.js"></script>
		
		<!-- Custom JS -->
		<script src="assets/js/script.js"></script>
	<script type="text/javascript">
		$(function () {
			//删除学生信息
			$(document).on('click',".btn-student-delete",function () {
					var id = $(this).parent().parent().parent().children('td').eq(0).text().trim();
					// alert(id)
					swal({
						title:"是否删除id："+id+"的学生",
						icon:"warning",
						buttons:{
							button1 : {
								text : "取消",
								value : false,
							},
							button2 : {
								text : "删除",
								value : true,
							}
						}
					}).then(function (isOk) {
						if (isOk){
							$.ajax({
								url:"./student.do",
								data:{
									id:id,
									action:'delete'
								},
								type:"get",
								success:function (data) {
									console.log(data)
									// window.location.reload()
									// location.href='./student.do?action=queryAll'
									if (data==1){
										swal({
											title: '删除成功',
											icon: 'success'
										}).then(function () {
											$.ajax({
												url:'./student.do',
												type: 'GET',
												data:{
													action:'queryAll'
												},
												success:function (data) {
													// location.href='./student.do?action=queryAll'
													window.location.reload()
												}
											})

										})
									}else{
										swal({
											title: '删除记录失败',
											icon: 'error'
										})
									}

								}
							})
							// location.href="./student.do?action=delete&id=" + id
						}

					})
					// location.href='./student.do?action=delete&id='+id;
				})

			//修改学生信息
			$(document).on('click',".btn-student-edit",function () {
				//获取学生id
					var id = $(this).parent().parent().parent().children('td').eq(0).text().trim();
					// var studentid = $(this).parent().parent().parent().children('td').eq(1).text().trim();
					// var name = $(this).parent().parent().parent().children('td').eq(2).text().trim();
					// var photograph = $(this).parent().parent().parent().children('td').eq(3).text().trim();
					// var idnumber = $(this).parent().parent().parent().children('td').eq(4).text().trim();
					// var sex = $(this).parent().parent().parent().children('td').eq(5).text().trim();
					// var admissiondate = $(this).parent().parent().parent().children('td').eq(6).text().trim();
					// var nation = $(this).parent().parent().parent().children('td').eq(7).text().trim();
					// var phone = $(this).parent().parent().parent().children('td').eq(8).text().trim();
					// var classgrade = $(this).parent().parent().parent().children('td').eq(9).text().trim();
					// var departmentid = $(this).parent().parent().parent().children('td').eq(10).text().trim();
					// var password = $(this).parent().parent().parent().children('td').eq(11).text().trim();
					// var native = $(this).parent().parent().parent().children('td').eq(12).text().trim();
					// var homeadress = $(this).parent().parent().parent().children('td').eq(13).text().trim();
					// var politicss = $(this).parent().parent().parent().children('td').eq(14).text().trim();
					// var birthdate = $(this).parent().parent().parent().children('td').eq(15).text().trim();
					// var majorid = $(this).parent().parent().parent().children('td').eq(16).text().trim();
					// var mailbox = $(this).parent().parent().parent().children('td').eq(17).text().trim();
					// var emergencycontact = $(this).parent().parent().parent().children('td').eq(18).text().trim();
					// var emergencycontactphone = $(this).parent().parent().parent().children('td').eq(19).text().trim();

					$.ajax({
						url:'./student.do?action=queryById',
						dataType:'text',
						type:'POST',
						data:{
							id:id,
						},
						success:function (data) {
							location.href='./edit-student.jsp'

						}
					})

				})

		})
	</script>

    </body>
</html>